ACCT
The ACCT dimension table contains records for each account in the GL of your organization. This includes accounts that can be found on the balance sheet, income statement, hours, and statistics.
Refer to the Axiom EPM Dimensions Setup files (AcctCoding sheet) for codes to use in \Axiom\Reports Library\System Files\Documents\Admin\Management Reporting\KHA EPM Dimensions Coding.xls.
NOTE: Some dimension tables are shared across multiple Axiom products. As a result, some of the columns listed in the following table may not display in the Dimension Maintenance Utility, depending on the Axiom products in which your organization is licensed.
The following table lists all of the options available in this dimension table:
Column | Description |
---|---|
ACCT | The Axiom Software account number. This can be the combination of the prime account and sub account, if that is how your GL system is set up. |
Description | The account description from the GL. Do not enter a description in all capital letters. To remove the all-caps format in the spreadsheet, use the Proper formula =Proper(). |
Credit |
Used during the interface process to reverse the signs so values are stored in a positive condition in the database. Select one of the following valid entries:
Normally, Revenue and Liabilities are C, and all others are dr. |
RptMap | Used to group accounts. Valid entries include any account numbers in the ACCT column. The system automatically copies the information in the ACCT column to this column during installation. |
Statement |
Used to identify the Financial Statement category. Select one of the following valid entries:
NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA. |
Type |
Used to identify the major Financial Statement category. Select one of the following valid entries:
NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA. |
FSSummary |
Used to identify summary-level Financial Statement categories. For the naming convention, use the first letter of the type category with an underscore and then the category name. For example, R_PatientRev or E_Salaries. NOTE: This is an Axiom standard column and categories cannot be added or edited. Default value is NA. |
FSDetail |
Used to identify line-item Financial Statement categories. For the naming convention, use the first letter of the type category with an underscore and then the category name. For example, R_IPRev, R_OPRev. For a list of the available options, see Options for Acct.FSDetail. NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA. |
FSPayor |
A variation of FSDetail used if GL accounts have payor categories; used for Budgeting Deductions models. If this is not used, match to FSDetail. Categories can be added or edited. The default value is a blank. |
FPCode | Used to identify the name of the Financial Planning category to use for summarization during the integration process with Axiom Financial Planning. If Axiom Financial Planning is not used, the default is NA. |
FSProvider |
Used to identify line-item Financial Statement categories. For the naming convention, use the first letter of the type category with an underscore and then the category name. For example, R_IPRev, R_OPRev. NOTE: This is only used if licensed for the Provider Budget Module. The default value is NA. |
FPCategory | Used to identify the name of the Financial Planning category to use for transferring the financial plan targets during the integration process with Axiom Financial Planning. If Axiom Financial Planning is not used, the default is NA. |
BPCode | Used to identify the payors from the Budget Deductions report. During installation, the system automatically copies the information from the FPCode column to this column. |
FlexStat | Identifies the primary statistic used for Flexible Budgeting. The most common set up is KeyTot for all stat, hours, and expenses. Revenue uses KeyIP for IP, KeyOP for OP, and KeyOth for other patient revenue. The default is NA. |
COSTCAT | Identifies the account category for Axiom Cost Accounting. |
FlexPercent | Identifies default variable percentage (0-100%) to use for Flexible Budgeting. Values should be entered as decimals, 0.75 = 75%. The default value is 0 (zero). |
CostMethod | Cost Method Indicator for Offset Accounts. |
FlexGroup | Used to group accounts together for Flexible Budgeting. For example, Medical Supplies or Other Expenses. The default is NA. |
CostVarPct | The Percent Variable for Axiom Cost Accounting; 0 = Fixed, which is used in the costing processes to determine the dollar weighted variability for calculation results. |
KHAInt |
Used to identify which tab an account should be interfaced to during the budget plan file create process. Valid entries include the following:
|
KHAStdLine | Used to identify default budget methodology used in budget plan files during budget plan file creation. Refer to calc methods for Stat_Rev sheet and Expense sheet in the Axiom Budgeting and Performance Reporting Administrator's Guide (Budget Plan Files chapter) for valid entries and definitions. The default value is NA. |
CostDSSSummary | Same as FSSummary but allows Costing and DSS to categorize their columns a bit differently and not impact Financial Reporting. |
KHABgtCode | Used for combining accounts together during budget plan file creation. If there are historical values for two accounts that you want to budget as one combined account, list the surviving account number on both lines. If not combining accounts, this value should match value in the Account column. The default value is 0 (zero). |
CostProvider | Used by the Axiom Cost Accounting system when performing the Provider RVU costing method. This identifies the cost information at the account level that is associated to the Provider, which is then allocated to his or her patients’ cost item or chargeable activities. |
BudgetType |
Used to identify which category an account should be interfaced to during the budget plan file interface process. If KHAInt = Stat_Rev, valid entries are:
If KHAInt = Expense, valid entries are:
The default value is NA. |
DropDown | Identifies Drop Down pick list when adding new accounts on Stat_Rev or Expense sheets in the budget plan file. It should be the same as value in BudgetType column. |
CDMStdLine |
Used to identify default budget methodology for CDM budget plan files (departments which have CDMStdLine in KHACMDimGrp column of DEPT Dimension) during budget plan file creation. It is used similarly to KHAStdLine in Budget Planning workbooks. Valid entries are:
Copy the remaining account assignments from KHAStdLine column. |
KHASum |
Used to summarize information from the Stat_Rev and Expense sheets to the Summary sheet within the budget plan files. NOTE: This is an Axiom standard column and categories cannot be added or edited. The default value is NA. |
CYPMethod |
Used to identify the methodology used for projecting the remainder of the current fiscal year. Valid entries are dependent upon values in KHAStdLine column:
|
PhyStdLine |
Used to identify default budget methodology used in the Provider budget plan files (departments which have PhyStdLine in KHACMDimGrp column of the DEPT dimension table) during budget plan file creation. Refer to Provider Version Only: Calc Methods - Stat_Rev Sheet and Expense Sheet in the Axiom Budgeting and Performance Reporting Administrator's Guide (Budget Plan Files chapter) for valid entries and definitions. The default value is NA. |
CYFMethod |
Used to identify the methodology used for projecting the remainder of the current fiscal year in the current year forecast utility. This utility is available in Axiom Budgeting and Performance Reporting in the Bud Admin task pane in Financial Reporting > Financial Utilities > Current Year Forecast. Statistics:
Revenue:
Salaries:
All Other Accounts: See Forecast Methods below Forecast Methods:
You can also add additional CYFMethod columns. Create a new CYFMethod column and use this in conjunction with the CYFDimGrp column in the DEPT dimension if you need to use a different CYP method for different departments. |
ReclassType | A grouping attribute that is useful in defining the type of reclass to use in the in Axiom Cost Accounting reclass functionality. |
AllocType | Defines the type of account for indirect allocations in Axiom Cost Accounting. |
BudStat |
Identifies Budget Statistic accounts used in Budget Statistics Driver. Standard entries are:
You can also create custom stats to use in the Budget Statistics Driver and identify accounts appropriately. The default value is a blank. |
CostAdjustmentID | Used in Costing to tie Allocation and Reclass StepIDs to ACCT numbers. |
CMStdLine | Used to identify the StdLine for Axiom Cost Management. |
KHAStandardClass | KHA standard classification used for reporting. |
BPCategory | Used to identify the Budget Planning category. |
NewDeptStdLine | Used to set or update the calc method for each department. |
InitStdLine |
Use to make accounts available for initiatives in the Axiom Budgeting budget workbook. In the Choose Value dialog for the InitStdLine, there are five validated values to select from. The following table lists the Initiative Standard Lines that we recommend you assign to each account type:
|
RFCode | Identifies the RFCode for account. Only used with Axiom Rolling Forecast. The default value is Z_Exclude. |
CM_Group | Used to summarize account types at a higher level for Axiom Cost Management analysis and reporting needs. |
InitType |
Used by the system to select the sections so that when the user refreshes the plan file, the accounts will insert into the appropriate section of the Initiative block in the Axiom Budgeting budget workbook. In the Choose Value dialog for the InitType, you can configure up to seventeen possible values. The section types available are noted in the following list. NA is the default value until configured or for any account not configured.
|
CM_NonLabor |
Used to classify non-labor accounts in Axiom Cost Management according to FSDetail. Valid entries include the following:
These classifications are used in reporting and plan creation. |
CM_Map | Used to map accounts together in Axiom Cost Management. You can use this column to map closed accounts with another existing account or to group like accounts. |
CM_TargetBgt | Used to create team workbooks in Axiom Cost Management at the account level. |